﻿if exists (select * from dbo.sysobjects where name = 'sp_tblOrderDetail_Update')
	drop procedure [dbo].[sp_tblOrderDetail_Update]
Go 
CREATE PROCEDURE dbo.sp_tblOrderDetail_Update
@_odid	int,
@_price	float,
@_quantity	int,
@_status	smallint,
@_timeship	datetime,
@_address	varchar
AS
UPDATE tblOrderDetail SET[_price] = @_price,[_quantity] = @_quantity,[_status] = @_status,[_timeship] = @_timeship,[_address] = @_address
WHERE  _odid= @_odid
Go

